I get the following message when executing a stored procedure.

The query has exceeded the maximum number of result sets that can be displayed in the results grid. Only the first 100 result sets...

well it just bounces ...

No error...

however the backup file is 0 bytes

Hi my friend , i have that .


/// <summary>
/// Backups are done here
/// </summary>
#region Backup Methods
#region Full Backup method
void...

:'( Hello everyone,

i wrote an application that makes database backups and zips them.

Can anyone please tell me what i need to do in order to get the apllication to work on IIS 6 windows server...

what exactly is a 'Database Schema' ?? and how can i make one ??

SELECT FILEGROUP_NAME(1) AS [Filegroup_Name];

This works cool and all , but i want all the stuff to display in one listbox ....

hey there lovely people, i am trying to make an application that makes database backups, now obviously i need to add the file / filegroup backup option too , which is not a problem except for this...

ok the error was found in the accountNumber columns, thanks anyway

Hey there, i really want to break my pc by now

can anyone tell me how to get around this ??

I just want to update the new database here


USE NGCOLLECT
GO

Hey hey

I have two tables with a lot of data, i need to insert certain column values from table one into table two - eg

Table one column = First_Name
Table two column = Name

I need to get...

Hi , I have 2 columns named

1. Tel_H
2. Tel_H_Code

How can i merge these two columns to make them one ??

I am clueless here...The best i can do is to view them as one

Oh cool this seems to work

SELECT name
FROM master.dbo.sysdatabases
WHERE name NOT IN ('master','model','msdb','tempdb')

Hey can anyone give me the query to retrieve a list of databases on a server rather than this query

SELECT NAME FROM sysobjects

which gives me a list of tables ????

Thank you