Insider’s Guide to Incident Response Read more in this insider's guide for expert tips on building a basic incident response plan and security process. Access Now
How can I see how many objects are actually open in SQL Server? Mar 04, 1999 A. On SQL 6.5 you can use the dbcc des command. This will list entries per open object. dbcc traceon(3604) go dbcc des go How can I restrict the number of rows returned to my query in SQL Server? Mar 04, 1999 A. With SQL 6.5 and below use the "set rowcount <n>"... How can I replace/change/delete characters in a SQL Server column? Mar 04, 1999 A. SQL has a reasonably full set of string manipulation tools - all... I am getting an error 603 on database recovery in a SQL 6.0 system. Mar 04, 1999 A. This happens only on SQL 6.0 SP3. There is no fix, but the... I am getting an error 2521 on my SQL Server - what can I do? Mar 04, 1999 A. Full error is "Msg 2521, Level 16, State 1, Server xxx, Table... I'm not seeing anything in the current activity screen in SQL EM. Mar 04, 1999 A. A. This is usually caused by the "select into/bulkcopy" database attribute for tempdb being unchecked. Set the option on again using SQL EM or sp_dboption and that should fix it. I'm getting an error 1117 in SQL Server. Can I rebuild the extents somehow? Mar 04, 1999 A. It is recommended that you select/bcp out all the relevant data... How do I register a SQL Server with SQL Enterprise Manager? Mar 04, 1999 A. A. Before you can control a SQL Server with the Enterprise Manager... How do I configure a connection to use tcp-ip sockets with SQL Server? Mar 04, 1999 A. Run the SQL Client Configuration program on the client in question... How can I tell what columns in my SQL Server database are identity columns? Mar 04, 1999 A. The following scripts work on SQL 6.5... Load More first previous … 1032 1033 1034 1035 1036 1037 1038 1039 1040 … next last Load More
How can I restrict the number of rows returned to my query in SQL Server? Mar 04, 1999 A. With SQL 6.5 and below use the "set rowcount <n>"... How can I replace/change/delete characters in a SQL Server column? Mar 04, 1999 A. SQL has a reasonably full set of string manipulation tools - all... I am getting an error 603 on database recovery in a SQL 6.0 system. Mar 04, 1999 A. This happens only on SQL 6.0 SP3. There is no fix, but the... I am getting an error 2521 on my SQL Server - what can I do? Mar 04, 1999 A. Full error is "Msg 2521, Level 16, State 1, Server xxx, Table... I'm not seeing anything in the current activity screen in SQL EM. Mar 04, 1999 A. A. This is usually caused by the "select into/bulkcopy" database attribute for tempdb being unchecked. Set the option on again using SQL EM or sp_dboption and that should fix it. I'm getting an error 1117 in SQL Server. Can I rebuild the extents somehow? Mar 04, 1999 A. It is recommended that you select/bcp out all the relevant data... How do I register a SQL Server with SQL Enterprise Manager? Mar 04, 1999 A. A. Before you can control a SQL Server with the Enterprise Manager... How do I configure a connection to use tcp-ip sockets with SQL Server? Mar 04, 1999 A. Run the SQL Client Configuration program on the client in question... How can I tell what columns in my SQL Server database are identity columns? Mar 04, 1999 A. The following scripts work on SQL 6.5... Load More first previous … 1032 1033 1034 1035 1036 1037 1038 1039 1040 … next last Load More
How can I replace/change/delete characters in a SQL Server column? Mar 04, 1999 A. SQL has a reasonably full set of string manipulation tools - all... I am getting an error 603 on database recovery in a SQL 6.0 system. Mar 04, 1999 A. This happens only on SQL 6.0 SP3. There is no fix, but the... I am getting an error 2521 on my SQL Server - what can I do? Mar 04, 1999 A. Full error is "Msg 2521, Level 16, State 1, Server xxx, Table... I'm not seeing anything in the current activity screen in SQL EM. Mar 04, 1999 A. A. This is usually caused by the "select into/bulkcopy" database attribute for tempdb being unchecked. Set the option on again using SQL EM or sp_dboption and that should fix it. I'm getting an error 1117 in SQL Server. Can I rebuild the extents somehow? Mar 04, 1999 A. It is recommended that you select/bcp out all the relevant data... How do I register a SQL Server with SQL Enterprise Manager? Mar 04, 1999 A. A. Before you can control a SQL Server with the Enterprise Manager... How do I configure a connection to use tcp-ip sockets with SQL Server? Mar 04, 1999 A. Run the SQL Client Configuration program on the client in question... How can I tell what columns in my SQL Server database are identity columns? Mar 04, 1999 A. The following scripts work on SQL 6.5... Load More first previous … 1032 1033 1034 1035 1036 1037 1038 1039 1040 … next last Load More
I am getting an error 603 on database recovery in a SQL 6.0 system. Mar 04, 1999 A. This happens only on SQL 6.0 SP3. There is no fix, but the... I am getting an error 2521 on my SQL Server - what can I do? Mar 04, 1999 A. Full error is "Msg 2521, Level 16, State 1, Server xxx, Table... I'm not seeing anything in the current activity screen in SQL EM. Mar 04, 1999 A. A. This is usually caused by the "select into/bulkcopy" database attribute for tempdb being unchecked. Set the option on again using SQL EM or sp_dboption and that should fix it. I'm getting an error 1117 in SQL Server. Can I rebuild the extents somehow? Mar 04, 1999 A. It is recommended that you select/bcp out all the relevant data... How do I register a SQL Server with SQL Enterprise Manager? Mar 04, 1999 A. A. Before you can control a SQL Server with the Enterprise Manager... How do I configure a connection to use tcp-ip sockets with SQL Server? Mar 04, 1999 A. Run the SQL Client Configuration program on the client in question... How can I tell what columns in my SQL Server database are identity columns? Mar 04, 1999 A. The following scripts work on SQL 6.5... Load More first previous … 1032 1033 1034 1035 1036 1037 1038 1039 1040 … next last Load More
I am getting an error 2521 on my SQL Server - what can I do? Mar 04, 1999 A. Full error is "Msg 2521, Level 16, State 1, Server xxx, Table... I'm not seeing anything in the current activity screen in SQL EM. Mar 04, 1999 A. A. This is usually caused by the "select into/bulkcopy" database attribute for tempdb being unchecked. Set the option on again using SQL EM or sp_dboption and that should fix it. I'm getting an error 1117 in SQL Server. Can I rebuild the extents somehow? Mar 04, 1999 A. It is recommended that you select/bcp out all the relevant data... How do I register a SQL Server with SQL Enterprise Manager? Mar 04, 1999 A. A. Before you can control a SQL Server with the Enterprise Manager... How do I configure a connection to use tcp-ip sockets with SQL Server? Mar 04, 1999 A. Run the SQL Client Configuration program on the client in question... How can I tell what columns in my SQL Server database are identity columns? Mar 04, 1999 A. The following scripts work on SQL 6.5... Load More first previous … 1032 1033 1034 1035 1036 1037 1038 1039 1040 … next last Load More
I'm not seeing anything in the current activity screen in SQL EM. Mar 04, 1999 A. A. This is usually caused by the "select into/bulkcopy" database attribute for tempdb being unchecked. Set the option on again using SQL EM or sp_dboption and that should fix it. I'm getting an error 1117 in SQL Server. Can I rebuild the extents somehow? Mar 04, 1999 A. It is recommended that you select/bcp out all the relevant data... How do I register a SQL Server with SQL Enterprise Manager? Mar 04, 1999 A. A. Before you can control a SQL Server with the Enterprise Manager... How do I configure a connection to use tcp-ip sockets with SQL Server? Mar 04, 1999 A. Run the SQL Client Configuration program on the client in question... How can I tell what columns in my SQL Server database are identity columns? Mar 04, 1999 A. The following scripts work on SQL 6.5... Load More first previous … 1032 1033 1034 1035 1036 1037 1038 1039 1040 … next last Load More
I'm getting an error 1117 in SQL Server. Can I rebuild the extents somehow? Mar 04, 1999 A. It is recommended that you select/bcp out all the relevant data... How do I register a SQL Server with SQL Enterprise Manager? Mar 04, 1999 A. A. Before you can control a SQL Server with the Enterprise Manager... How do I configure a connection to use tcp-ip sockets with SQL Server? Mar 04, 1999 A. Run the SQL Client Configuration program on the client in question... How can I tell what columns in my SQL Server database are identity columns? Mar 04, 1999 A. The following scripts work on SQL 6.5... Load More first previous … 1032 1033 1034 1035 1036 1037 1038 1039 1040 … next last Load More
How do I register a SQL Server with SQL Enterprise Manager? Mar 04, 1999 A. A. Before you can control a SQL Server with the Enterprise Manager... How do I configure a connection to use tcp-ip sockets with SQL Server? Mar 04, 1999 A. Run the SQL Client Configuration program on the client in question... How can I tell what columns in my SQL Server database are identity columns? Mar 04, 1999 A. The following scripts work on SQL 6.5... Load More first previous … 1032 1033 1034 1035 1036 1037 1038 1039 1040 … next last Load More
How do I configure a connection to use tcp-ip sockets with SQL Server? Mar 04, 1999 A. Run the SQL Client Configuration program on the client in question... How can I tell what columns in my SQL Server database are identity columns? Mar 04, 1999 A. The following scripts work on SQL 6.5... Load More first previous … 1032 1033 1034 1035 1036 1037 1038 1039 1040 … next last Load More
How can I tell what columns in my SQL Server database are identity columns? Mar 04, 1999 A. The following scripts work on SQL 6.5... Load More first previous … 1032 1033 1034 1035 1036 1037 1038 1039 1040 … next last Load More
